home *** CD-ROM | disk | FTP | other *** search
/ The Games Machine 103 / XENIATGM103.iso / Shareware / GoLive 5.0 / MM9.Cab / F1462_table.asp.9B3B646D_CB56_4EAE_BAB7_3E7E8E41A649 < prev    next >
Text File  |  2000-08-17  |  3KB  |  73 lines
  1. <!-- #INCLUDE VIRTUAL="/golive/config/include/utils.runtime5.asp" -->
  2. <!-- #INCLUDE VIRTUAL="/golive/config/include/ado.runtime5.asp" -->
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2//EN">
  4. <html>
  5.  
  6.     <head>
  7.         <meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
  8.         <meta name="generator" content="Adobe GoLive 5">
  9.         <title>Creating a Dynamic Table</title>
  10.         <%'Dynamic Link
  11.            set Product_InformationRecordSet = CreateObject("ADODB.RecordSet")
  12.            Product_InformationRecordSet.Open "select * from Products where Category = 'Saw Blades'", ConnectString("LooseScrews")
  13.            set Product_Information = WrapRecordSet(Product_InformationRecordSet, "ProductID")
  14.         %><meta name="site-config-URL" content="http://localhost/golive/config/">
  15.     </head>
  16.  
  17.     <body bgcolor="white">
  18.         <table border="0" cellpadding="15" cellspacing="0">
  19.             <tr>
  20.                 <td colspan="2" valign="top">
  21.                     <h2><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Creating a Dynamic Table</font></h2>
  22.                 </td>
  23.             </tr>
  24.             <tr>
  25.                 <td width="194" valign="top">
  26.                     <table border="0" cellpadding="5" cellspacing="0">
  27.                         <tr>
  28.                             <td valign="top">1.</td>
  29.                             <td><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Layout a template table using the same formatting that the final table should have.</font></td>
  30.                         </tr>
  31.                         <tr>
  32.                             <td valign="top">2.</td>
  33.                             <td><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Bind the elements in the first row you want to replace to appropriate pieces of dynamic content.</font></td>
  34.                         </tr>
  35.                         <tr>
  36.                             <td valign="top">3.</td>
  37.                             <td><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Select the table.</font></td>
  38.                         </tr>
  39.                         <tr>
  40.                             <td valign="top">4.</td>
  41.                             <td><font face="Arial,Helvetica,Geneva,Swiss,SunSans-Regular">Check the Replace Rows option in the Binding Details tab of the Dynamic Link palette.</font></td>
  42.                         </tr>
  43.                     </table>
  44.                 </td>
  45.                 <td valign="top"><b>
  46.                     <table border="1" cellpadding="3" cellspacing="0">
  47.                         <tr>
  48.                             <td width="170" bgcolor="#666699"><font color="white"><b>Product Type</b></font></td>
  49.                             <td width="94" bgcolor="#666699"><font color="white"><b>Price</b></font></td>
  50.                         </tr>
  51.                         <% Product_Information.MoveFirst %>
  52.                             <% while not Product_Information.EOF %>
  53.                             <tr>
  54.                             <td width="170"><%=Product_Information.Value("Type")%></td>
  55.                             <td width="94">$<%=Product_Information.Value("Price")%></td>
  56.                         </tr>
  57.                             <% Product_Information.MoveNext %>
  58.                             <% wend %>
  59.                         </table>
  60.                     </b></td>
  61.             </tr>
  62.         </table>
  63.     </body>
  64.  
  65. </html>
  66. <% if 0 then %>
  67. <!-- Mock Content
  68.    Product_Information:<TABLE> {<tr><td width="170">Classic Quacker</td><td width="94">$25</td></tr><tr><td width="170">Mr. Yellow</td><td width="94">$18</td></tr>}
  69.    Product_Information:Type {Grandpa's Favorite}
  70.    Product_Information:Price {100}
  71. -->
  72. <% end if %>
  73.